Dataset info
| Number of variables | 18 |
|---|---|
| Number of observations | 756 |
| Missing cells | 656 (4.8%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 676.0 KiB |
| Average record size in memory | 915.7 B |
Variables types
| CAT | 13 |
|---|---|
| NUM | 4 |
| BOOL | 1 |
Reproduction info
| Date of analysis | 2020-08-30 15:40:03.536073 |
|---|---|
| Version | pandas-profiling v2.4.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download Configuration | config.yaml |
Warnings
date has a high cardinality: 546 distinct values | Warning |
player_of_match has a high cardinality: 227 distinct values | Warning |
umpire1 has a high cardinality: 62 distinct values | Warning |
umpire2 has a high cardinality: 66 distinct values | Warning |
umpire3 has 637 (84.3%) missing values | Missing |
win_by_runs has 419 (55.4%) zeros | Zeros |
win_by_wickets has 350 (46.3%) zeros | Zeros |
city
Categorical
| Distinct count | 33 |
|---|---|
| Unique (%) | 4.4% |
| Missing | 7 |
| Missing (%) | 0.9% |
| Memory size | 6.0 KiB |
| Mumbai | |
|---|---|
| Kolkata | |
| Delhi | |
| Bangalore | 66 |
| Hyderabad | 64 |
| Other values (27) |
| Value | Count | Frequency (%) | |
| Mumbai | 101 | 13.4% | |
| Kolkata | 77 | 10.2% | |
| Delhi | 74 | 9.8% | |
| Bangalore | 66 | 8.7% | |
| Hyderabad | 64 | 8.5% | |
| Chennai | 57 | 7.5% | |
| Jaipur | 47 | 6.2% | |
| Chandigarh | 46 | 6.1% | |
| Pune | 38 | 5.0% | |
| Durban | 15 | 2.0% | |
| Other values (22) | 164 | 21.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 14 |
|---|---|
| Mean length | 7.28042328 |
| Min length | 3 |
| Distinct count | 546 |
|---|---|
| Unique (%) | 72.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| 2009-05-03 | 2 |
|---|---|
| 2015-05-16 | 2 |
| 2013-04-13 | 2 |
| 2017-04-29 | 2 |
| 2012-04-10 | 2 |
| Other values (541) |
| Value | Count | Frequency (%) | |
| 2009-05-03 | 2 | 0.3% | |
| 2015-05-16 | 2 | 0.3% | |
| 2013-04-13 | 2 | 0.3% | |
| 2017-04-29 | 2 | 0.3% | |
| 2012-04-10 | 2 | 0.3% | |
| 2012-05-17 | 2 | 0.3% | |
| 05/05/19 | 2 | 0.3% | |
| 13/05/18 | 2 | 0.3% | |
| 2017-05-13 | 2 | 0.3% | |
| 2014-05-24 | 2 | 0.3% | |
| Other values (536) | 736 | 97.4% |
Composition
| Contains chars | False |
|---|---|
| Contains digits | True |
| Contains whitespace | False |
| Contains non-words | True |
Length
| Max length | 10 |
|---|---|
| Mean length | 9.682539683 |
| Min length | 8 |
dl_applied
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| 0 | |
|---|---|
| 1 | 19 |
| Value | Count | Frequency (%) | |
| 0 | 737 | 97.5% | |
| 1 | 19 | 2.5% |
| Distinct count | 756 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1792.178571 |
|---|---|
| Minimum | 1 |
| Maximum | 11415 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 38.75 |
| Q1 | 189.75 |
| median | 378.5 |
| Q3 | 567.25 |
| 95-th percentile | 11313.25 |
| Maximum | 11415 |
| Range | 11414 |
| Interquartile range (IQR) | 377.5 |
Descriptive statistics
| Standard deviation | 3464.478148 |
|---|---|
| Coefficient of variation (CV) | 1.933109905 |
| Kurtosis | 2.315967886 |
| Mean | 1792.178571 |
| Median Absolute Deviation (MAD) | 2479.522676 |
| Skewness | 2.011635837 |
| Sum | 1354887 |
| Variance | 12002608.84 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1.00000e+00 6.35500e+02 7.89450e+03 7.95250e+03 1.11375e+04 1.11525e+04 1.13095e+04 1.13465e+04 1.14125e+04 1.14150e+04], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 11311 | 1 | 0.1% | |
| 248 | 1 | 0.1% | |
| 257 | 1 | 0.1% | |
| 256 | 1 | 0.1% | |
| 255 | 1 | 0.1% | |
| 254 | 1 | 0.1% | |
| 253 | 1 | 0.1% | |
| 252 | 1 | 0.1% | |
| 251 | 1 | 0.1% | |
| 250 | 1 | 0.1% | |
| Other values (746) | 746 | 98.7% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.1% | |
| 2 | 1 | 0.1% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% | |
| 5 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 11415 | 1 | 0.1% | |
| 11414 | 1 | 0.1% | |
| 11413 | 1 | 0.1% | |
| 11412 | 1 | 0.1% | |
| 11347 | 1 | 0.1% |
| Distinct count | 227 |
|---|---|
| Unique (%) | 30.0% |
| Missing | 4 |
| Missing (%) | 0.5% |
| Memory size | 6.0 KiB |
| CH Gayle | 21 |
|---|---|
| AB de Villiers | 20 |
| RG Sharma | 17 |
| MS Dhoni | 17 |
| DA Warner | 17 |
| Other values (221) |
| Value | Count | Frequency (%) | |
| CH Gayle | 21 | 2.8% | |
| AB de Villiers | 20 | 2.6% | |
| RG Sharma | 17 | 2.2% | |
| MS Dhoni | 17 | 2.2% | |
| DA Warner | 17 | 2.2% | |
| YK Pathan | 16 | 2.1% | |
| SR Watson | 15 | 2.0% | |
| SK Raina | 14 | 1.9% | |
| G Gambhir | 13 | 1.7% | |
| AM Rahane | 12 | 1.6% | |
| Other values (216) | 590 | 78.0% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 17 |
|---|---|
| Mean length | 9.388888889 |
| Min length | 3 |
result
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| normal | |
|---|---|
| tie | 9 |
| no result | 4 |
| Value | Count | Frequency (%) | |
| normal | 743 | 98.3% | |
| tie | 9 | 1.2% | |
| no result | 4 | 0.5% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 9 |
|---|---|
| Mean length | 5.98015873 |
| Min length | 3 |
season
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2013.444444 |
|---|---|
| Minimum | 2008 |
| Maximum | 2019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 2008 |
|---|---|
| 5-th percentile | 2008 |
| Q1 | 2011 |
| median | 2013 |
| Q3 | 2016 |
| 95-th percentile | 2019 |
| Maximum | 2019 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.366895059 |
|---|---|
| Coefficient of variation (CV) | 0.001672206585 |
| Kurtosis | -1.142756042 |
| Mean | 2013.444444 |
| Median Absolute Deviation (MAD) | 2.896531452 |
| Skewness | 0.0603368179 |
| Sum | 1522164 |
| Variance | 11.33598234 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[2008. 2008.5 2018.5 2019. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2013 | 76 | 10.1% | |
| 2012 | 74 | 9.8% | |
| 2011 | 73 | 9.7% | |
| 2019 | 60 | 7.9% | |
| 2018 | 60 | 7.9% | |
| 2016 | 60 | 7.9% | |
| 2014 | 60 | 7.9% | |
| 2010 | 60 | 7.9% | |
| 2017 | 59 | 7.8% | |
| 2015 | 59 | 7.8% | |
| Other values (2) | 115 | 15.2% |
| Value | Count | Frequency (%) | |
| 2008 | 58 | 7.7% | |
| 2009 | 57 | 7.5% | |
| 2010 | 60 | 7.9% | |
| 2011 | 73 | 9.7% | |
| 2012 | 74 | 9.8% |
| Value | Count | Frequency (%) | |
| 2019 | 60 | 7.9% | |
| 2018 | 60 | 7.9% | |
| 2017 | 59 | 7.8% | |
| 2016 | 60 | 7.9% | |
| 2015 | 59 | 7.8% |
team1
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| Mumbai Indians | |
|---|---|
| Kings XI Punjab | |
| Chennai Super Kings | |
| Royal Challengers Bangalore | |
| Kolkata Knight Riders | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 101 | 13.4% | |
| Kings XI Punjab | 91 | 12.0% | |
| Chennai Super Kings | 89 | 11.8% | |
| Royal Challengers Bangalore | 85 | 11.2% | |
| Kolkata Knight Riders | 83 | 11.0% | |
| Delhi Daredevils | 72 | 9.5% | |
| Rajasthan Royals | 67 | 8.9% | |
| Sunrisers Hyderabad | 63 | 8.3% | |
| Deccan Chargers | 43 | 5.7% | |
| Pune Warriors | 20 | 2.6% | |
| Other values (5) | 42 | 5.6% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 17.95899471 |
| Min length | 13 |
team2
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| Royal Challengers Bangalore | |
|---|---|
| Kolkata Knight Riders | |
| Delhi Daredevils | |
| Mumbai Indians | |
| Kings XI Punjab | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| Royal Challengers Bangalore | 95 | 12.6% | |
| Kolkata Knight Riders | 95 | 12.6% | |
| Delhi Daredevils | 89 | 11.8% | |
| Mumbai Indians | 86 | 11.4% | |
| Kings XI Punjab | 85 | 11.2% | |
| Rajasthan Royals | 80 | 10.6% | |
| Chennai Super Kings | 75 | 9.9% | |
| Sunrisers Hyderabad | 45 | 6.0% | |
| Deccan Chargers | 32 | 4.2% | |
| Pune Warriors | 26 | 3.4% | |
| Other values (5) | 48 | 6.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 18.07671958 |
| Min length | 13 |
toss_decision
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| field | |
|---|---|
| bat |
| Value | Count | Frequency (%) | |
| field | 463 | 61.2% | |
| bat | 293 | 38.8% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | False |
| Contains non-words | False |
Length
| Max length | 5 |
|---|---|
| Mean length | 4.224867725 |
| Min length | 3 |
toss_winner
Categorical
| Distinct count | 15 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| Mumbai Indians | |
|---|---|
| Kolkata Knight Riders | |
| Chennai Super Kings | |
| Kings XI Punjab | |
| Royal Challengers Bangalore | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 98 | 13.0% | |
| Kolkata Knight Riders | 92 | 12.2% | |
| Chennai Super Kings | 89 | 11.8% | |
| Kings XI Punjab | 81 | 10.7% | |
| Royal Challengers Bangalore | 81 | 10.7% | |
| Delhi Daredevils | 80 | 10.6% | |
| Rajasthan Royals | 80 | 10.6% | |
| Sunrisers Hyderabad | 46 | 6.1% | |
| Deccan Chargers | 43 | 5.7% | |
| Pune Warriors | 20 | 2.6% | |
| Other values (5) | 46 | 6.1% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 17.88888889 |
| Min length | 13 |
| Distinct count | 62 |
|---|---|
| Unique (%) | 8.2% |
| Missing | 2 |
| Missing (%) | 0.3% |
| Memory size | 6.0 KiB |
| HDPK Dharmasena | 73 |
|---|---|
| Asad Rauf | 51 |
| S Ravi | 49 |
| AK Chaudhary | 43 |
| Aleem Dar | 38 |
| Other values (56) |
| Value | Count | Frequency (%) | |
| HDPK Dharmasena | 73 | 9.7% | |
| Asad Rauf | 51 | 6.7% | |
| S Ravi | 49 | 6.5% | |
| AK Chaudhary | 43 | 5.7% | |
| Aleem Dar | 38 | 5.0% | |
| BF Bowden | 37 | 4.9% | |
| BR Doctrove | 34 | 4.5% | |
| M Erasmus | 32 | 4.2% | |
| Nitin Menon | 20 | 2.6% | |
| RE Koertzen | 20 | 2.6% | |
| Other values (51) | 357 | 47.2% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 21 |
|---|---|
| Mean length | 10.73809524 |
| Min length | 3 |
| Distinct count | 66 |
|---|---|
| Unique (%) | 8.7% |
| Missing | 2 |
| Missing (%) | 0.3% |
| Memory size | 6.0 KiB |
| S Ravi | 57 |
|---|---|
| C Shamshuddin | 57 |
| SJA Taufel | 54 |
| RJ Tucker | 38 |
| CK Nandan | 36 |
| Other values (60) |
| Value | Count | Frequency (%) | |
| S Ravi | 57 | 7.5% | |
| C Shamshuddin | 57 | 7.5% | |
| SJA Taufel | 54 | 7.1% | |
| RJ Tucker | 38 | 5.0% | |
| CK Nandan | 36 | 4.8% | |
| RB Tiffin | 30 | 4.0% | |
| VA Kulkarni | 28 | 3.7% | |
| SK Tarapore | 26 | 3.4% | |
| BNJ Oxenford | 25 | 3.3% | |
| AM Saheba | 23 | 3.0% | |
| Other values (55) | 380 | 50.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 21 |
|---|---|
| Mean length | 10.46296296 |
| Min length | 3 |
| Distinct count | 26 |
|---|---|
| Unique (%) | 3.4% |
| Missing | 637 |
| Missing (%) | 84.3% |
| Memory size | 6.0 KiB |
| Nitin Menon | 10 |
|---|---|
| O Nandan | 10 |
| C Shamshuddin | 10 |
| Anil Chaudhary | 9 |
| S Ravi | 8 |
| Other values (20) |
| Value | Count | Frequency (%) | |
| Nitin Menon | 10 | 1.3% | |
| O Nandan | 10 | 1.3% | |
| C Shamshuddin | 10 | 1.3% | |
| Anil Chaudhary | 9 | 1.2% | |
| S Ravi | 8 | 1.1% | |
| Vineet Kulkarni | 8 | 1.1% | |
| Yeshwant Barde | 7 | 0.9% | |
| Bruce Oxenford | 7 | 0.9% | |
| Anil Dandekar | 7 | 0.9% | |
| Chris Gaffaney | 6 | 0.8% | |
| Other values (15) | 37 | 4.9% | |
| (Missing) | 637 | 84.3% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 23 |
|---|---|
| Mean length | 4.510582011 |
| Min length | 3 |
venue
Categorical
| Distinct count | 41 |
|---|---|
| Unique (%) | 5.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 KiB |
| Eden Gardens | 77 |
|---|---|
| Wankhede Stadium | 73 |
| M Chinnaswamy Stadium | 73 |
| Feroz Shah Kotla | 67 |
| Rajiv Gandhi International Stadium, Uppal | 56 |
| Other values (36) |
| Value | Count | Frequency (%) | |
| Eden Gardens | 77 | 10.2% | |
| Wankhede Stadium | 73 | 9.7% | |
| M Chinnaswamy Stadium | 73 | 9.7% | |
| Feroz Shah Kotla | 67 | 8.9% | |
| Rajiv Gandhi International Stadium, Uppal | 56 | 7.4% | |
| MA Chidambaram Stadium, Chepauk | 49 | 6.5% | |
| Sawai Mansingh Stadium | 47 | 6.2% | |
| Punjab Cricket Association Stadium, Mohali | 35 | 4.6% | |
| Maharashtra Cricket Association Stadium | 21 | 2.8% | |
| Dr DY Patil Sports Academy | 17 | 2.2% | |
| Other values (31) | 241 | 31.9% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 52 |
|---|---|
| Mean length | 24.63095238 |
| Min length | 8 |
| Distinct count | 89 |
|---|---|
| Unique (%) | 11.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.28306878 |
|---|---|
| Minimum | 0 |
| Maximum | 146 |
| Zeros | 419 |
| Zeros (%) | 55.4% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 19 |
| 95-th percentile | 64.25 |
| Maximum | 146 |
| Range | 146 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 23.47114399 |
|---|---|
| Coefficient of variation (CV) | 1.766997098 |
| Kurtosis | 7.629016841 |
| Mean | 13.28306878 |
| Median Absolute Deviation (MAD) | 16.4233994 |
| Skewness | 2.551532466 |
| Sum | 10042 |
| Variance | 550.8946004 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 25.5 46.5 97.5 146. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 419 | 55.4% | |
| 14 | 13 | 1.7% | |
| 4 | 11 | 1.5% | |
| 10 | 11 | 1.5% | |
| 1 | 10 | 1.3% | |
| 13 | 9 | 1.2% | |
| 23 | 9 | 1.2% | |
| 15 | 9 | 1.2% | |
| 7 | 9 | 1.2% | |
| 9 | 9 | 1.2% | |
| Other values (79) | 247 | 32.7% |
| Value | Count | Frequency (%) | |
| 0 | 419 | 55.4% | |
| 1 | 10 | 1.3% | |
| 2 | 7 | 0.9% | |
| 3 | 5 | 0.7% | |
| 4 | 11 | 1.5% |
| Value | Count | Frequency (%) | |
| 146 | 1 | 0.1% | |
| 144 | 1 | 0.1% | |
| 140 | 1 | 0.1% | |
| 138 | 1 | 0.1% | |
| 130 | 1 | 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.350529101 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros | 350 |
| Zeros (%) | 46.3% |
| Memory size | 6.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 9 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.387962678 |
|---|---|
| Coefficient of variation (CV) | 1.011172438 |
| Kurtosis | -1.51665661 |
| Mean | 3.350529101 |
| Median Absolute Deviation (MAD) | 3.159125584 |
| Skewness | 0.2702362057 |
| Sum | 2533 |
| Variance | 11.47829111 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 2.5 3.5 4.5 8.5 10. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 350 | 46.3% | |
| 6 | 85 | 11.2% | |
| 7 | 80 | 10.6% | |
| 5 | 71 | 9.4% | |
| 8 | 54 | 7.1% | |
| 4 | 41 | 5.4% | |
| 9 | 37 | 4.9% | |
| 3 | 18 | 2.4% | |
| 10 | 11 | 1.5% | |
| 2 | 6 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 350 | 46.3% | |
| 1 | 3 | 0.4% | |
| 2 | 6 | 0.8% | |
| 3 | 18 | 2.4% | |
| 4 | 41 | 5.4% |
| Value | Count | Frequency (%) | |
| 10 | 11 | 1.5% | |
| 9 | 37 | 4.9% | |
| 8 | 54 | 7.1% | |
| 7 | 80 | 10.6% | |
| 6 | 85 | 11.2% |
winner
Categorical
| Distinct count | 16 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 4 |
| Missing (%) | 0.5% |
| Memory size | 6.0 KiB |
| Mumbai Indians | |
|---|---|
| Chennai Super Kings | |
| Kolkata Knight Riders | |
| Royal Challengers Bangalore | |
| Kings XI Punjab | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| Mumbai Indians | 109 | 14.4% | |
| Chennai Super Kings | 100 | 13.2% | |
| Kolkata Knight Riders | 92 | 12.2% | |
| Royal Challengers Bangalore | 84 | 11.1% | |
| Kings XI Punjab | 82 | 10.8% | |
| Rajasthan Royals | 75 | 9.9% | |
| Delhi Daredevils | 67 | 8.9% | |
| Sunrisers Hyderabad | 58 | 7.7% | |
| Deccan Chargers | 29 | 3.8% | |
| Gujarat Lions | 13 | 1.7% | |
| Other values (5) | 43 | 5.7% |
Composition
| Contains chars | True |
|---|---|
| Contains digits | False |
| Contains whitespace | True |
| Contains non-words | True |
Length
| Max length | 27 |
|---|---|
| Mean length | 17.98544974 |
| Min length | 3 |
First rows
| city | date | dl_applied | id | player_of_match | result | season | team1 | team2 | toss_decision | toss_winner | umpire1 | umpire2 | umpire3 | venue | win_by_runs | win_by_wickets | winner | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Hyderabad | 2017-04-05 | 0 | 1 | Yuvraj Singh | normal | 2017 | Sunrisers Hyderabad | Royal Challengers Bangalore | field | Royal Challengers Bangalore | AY Dandekar | NJ Llong | NaN | Rajiv Gandhi International Stadium, Uppal | 35 | 0 | Sunrisers Hyderabad |
| 1 | Pune | 2017-04-06 | 0 | 2 | SPD Smith | normal | 2017 | Mumbai Indians | Rising Pune Supergiant | field | Rising Pune Supergiant | A Nand Kishore | S Ravi | NaN | Maharashtra Cricket Association Stadium | 0 | 7 | Rising Pune Supergiant |
| 2 | Rajkot | 2017-04-07 | 0 | 3 | CA Lynn | normal | 2017 | Gujarat Lions | Kolkata Knight Riders | field | Kolkata Knight Riders | Nitin Menon | CK Nandan | NaN | Saurashtra Cricket Association Stadium | 0 | 10 | Kolkata Knight Riders |
| 3 | Indore | 2017-04-08 | 0 | 4 | GJ Maxwell | normal | 2017 | Rising Pune Supergiant | Kings XI Punjab | field | Kings XI Punjab | AK Chaudhary | C Shamshuddin | NaN | Holkar Cricket Stadium | 0 | 6 | Kings XI Punjab |
| 4 | Bangalore | 2017-04-08 | 0 | 5 | KM Jadhav | normal | 2017 | Royal Challengers Bangalore | Delhi Daredevils | bat | Royal Challengers Bangalore | NaN | NaN | NaN | M Chinnaswamy Stadium | 15 | 0 | Royal Challengers Bangalore |
| 5 | Hyderabad | 2017-04-09 | 0 | 6 | Rashid Khan | normal | 2017 | Gujarat Lions | Sunrisers Hyderabad | field | Sunrisers Hyderabad | A Deshmukh | NJ Llong | NaN | Rajiv Gandhi International Stadium, Uppal | 0 | 9 | Sunrisers Hyderabad |
| 6 | Mumbai | 2017-04-09 | 0 | 7 | N Rana | normal | 2017 | Kolkata Knight Riders | Mumbai Indians | field | Mumbai Indians | Nitin Menon | CK Nandan | NaN | Wankhede Stadium | 0 | 4 | Mumbai Indians |
| 7 | Indore | 2017-04-10 | 0 | 8 | AR Patel | normal | 2017 | Royal Challengers Bangalore | Kings XI Punjab | bat | Royal Challengers Bangalore | AK Chaudhary | C Shamshuddin | NaN | Holkar Cricket Stadium | 0 | 8 | Kings XI Punjab |
| 8 | Pune | 2017-04-11 | 0 | 9 | SV Samson | normal | 2017 | Delhi Daredevils | Rising Pune Supergiant | field | Rising Pune Supergiant | AY Dandekar | S Ravi | NaN | Maharashtra Cricket Association Stadium | 97 | 0 | Delhi Daredevils |
| 9 | Mumbai | 2017-04-12 | 0 | 10 | JJ Bumrah | normal | 2017 | Sunrisers Hyderabad | Mumbai Indians | field | Mumbai Indians | Nitin Menon | CK Nandan | NaN | Wankhede Stadium | 0 | 4 | Mumbai Indians |
Last rows
| city | date | dl_applied | id | player_of_match | result | season | team1 | team2 | toss_decision | toss_winner | umpire1 | umpire2 | umpire3 | venue | win_by_runs | win_by_wickets | winner | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746 | Mumbai | 02/05/19 | 0 | 11342 | JJ Bumrah | tie | 2019 | Mumbai Indians | Sunrisers Hyderabad | bat | Mumbai Indians | S Ravi | O Nandan | Nanda Kishore | Wankhede Stadium | 0 | 0 | Mumbai Indians |
| 747 | Mohali | 03/05/19 | 0 | 11343 | S Gill | normal | 2019 | Kings XI Punjab | Kolkata Knight Riders | field | Kolkata Knight Riders | Bruce Oxenford | C Shamshuddin | KN Ananthapadmanabhan | IS Bindra Stadium | 0 | 7 | Kolkata Knight Riders |
| 748 | Delhi | 04/05/19 | 0 | 11344 | A Mishra | normal | 2019 | Rajasthan Royals | Delhi Capitals | bat | Rajasthan Royals | Ian Gould | Anil Dandekar | Nitin Menon | Feroz Shah Kotla Ground | 0 | 5 | Delhi Capitals |
| 749 | Bengaluru | 04/05/19 | 0 | 11345 | S Hetmyer | normal | 2019 | Sunrisers Hyderabad | Royal Challengers Bangalore | field | Royal Challengers Bangalore | Nigel Llong | Anil Chaudhary | Ulhas Gandhe | M. Chinnaswamy Stadium | 0 | 4 | Royal Challengers Bangalore |
| 750 | Mohali | 05/05/19 | 0 | 11346 | KL Rahul | normal | 2019 | Chennai Super Kings | Kings XI Punjab | field | Kings XI Punjab | KN Ananthapadmanabhan | C Shamshuddin | Bruce Oxenford | IS Bindra Stadium | 0 | 6 | Kings XI Punjab |
| 751 | Mumbai | 05/05/19 | 0 | 11347 | HH Pandya | normal | 2019 | Kolkata Knight Riders | Mumbai Indians | field | Mumbai Indians | Nanda Kishore | O Nandan | S Ravi | Wankhede Stadium | 0 | 9 | Mumbai Indians |
| 752 | Chennai | 07/05/19 | 0 | 11412 | AS Yadav | normal | 2019 | Chennai Super Kings | Mumbai Indians | bat | Chennai Super Kings | Nigel Llong | Nitin Menon | Ian Gould | M. A. Chidambaram Stadium | 0 | 6 | Mumbai Indians |
| 753 | Visakhapatnam | 08/05/19 | 0 | 11413 | RR Pant | normal | 2019 | Sunrisers Hyderabad | Delhi Capitals | field | Delhi Capitals | NaN | NaN | NaN | ACA-VDCA Stadium | 0 | 2 | Delhi Capitals |
| 754 | Visakhapatnam | 10/05/19 | 0 | 11414 | F du Plessis | normal | 2019 | Delhi Capitals | Chennai Super Kings | field | Chennai Super Kings | Sundaram Ravi | Bruce Oxenford | Chettithody Shamshuddin | ACA-VDCA Stadium | 0 | 6 | Chennai Super Kings |
| 755 | Hyderabad | 12/05/19 | 0 | 11415 | JJ Bumrah | normal | 2019 | Mumbai Indians | Chennai Super Kings | bat | Mumbai Indians | Nitin Menon | Ian Gould | Nigel Llong | Rajiv Gandhi Intl. Cricket Stadium | 1 | 0 | Mumbai Indians |